﻿CREATE PROCEDURE [dbo].[proc_Finance_Profit_Regulate_GetItem]
	(
		@Id int
	)
AS
	Select
	   [Id]
      ,[CompanyId]
      ,[CompanyName]
      ,[Summary]
      ,[Amount]
      ,[FillOutUserId]
      ,[FillOutUserName]
      ,[RegulateDate]
      ,[FillOutDate]
      ,[Deleted]
	  ,[Approval]
      ,[ApprovalComments]
      ,[ApprovalUserId]
      ,[ApprovalName]
      ,[ApprovalTime]
	From Finance_Profit_Regulate Where Id=@Id
	RETURN
